SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{1bf2ab4e9db0f1fd58bd6949316bdeb718a16af7d0fb7c489f931b83961830c0}Cancelada{1bf2ab4e9db0f1fd58bd6949316bdeb718a16af7d0fb7c489f931b83961830c0}' OR prCity = 'Cancelada' OR prZip = 'Cancelada' OR prStreet LIKE '{1bf2ab4e9db0f1fd58bd6949316bdeb718a16af7d0fb7c489f931b83961830c0}Cancelada{1bf2ab4e9db0f1fd58bd6949316bdeb718a16af7d0fb7c489f931b83961830c0}' OR prCountry = 'Cancelada') AND (prLocation LIKE '{1bf2ab4e9db0f1fd58bd6949316bdeb718a16af7d0fb7c489f931b83961830c0}Spain{1bf2ab4e9db0f1fd58bd6949316bdeb718a16af7d0fb7c489f931b83961830c0}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{1bf2ab4e9db0f1fd58bd6949316bdeb718a16af7d0fb7c489f931b83961830c0}Spain{1bf2ab4e9db0f1fd58bd6949316bdeb718a16af7d0fb7c489f931b83961830c0}' OR prCountry = 'Spain')